Aspect Extraction and Sentiment Analysis of Google Reviews
Part1: Aspect Extraction
Customer reviews in tabular form
| User | Date | Review | Likes | Response | Response_Date | Rating | |
|---|---|---|---|---|---|---|---|
| 0 | haru maru | 2024-06-25 | Prices be high any time i ask why i be give th... | Like | Hello. We're very sorry to hear about your exp... | a week ago | 1 |
| 1 | The Luxury Spa | 2024-05-09 | service be horrible I have never see a Utility... | 3 | Hello. We're very sorry to hear about your exp... | 2 months ago | 1 |
| 2 | Sam Peachey | 2024-06-09 | If you have the option of use RG&E do not . I ... | 5 | We're very sorry to hear about your experience... | a month ago | 1 |
| 3 | Ms M | 2024-06-09 | They tell you to enter a meter read .. I do it... | 3 | We're very sorry to hear about your experience... | a month ago | 2 |
| 4 | Phoebe Hernick | 2024-05-09 | I schedule a meter reading , and the meter rea... | 2 | Hi Phoebe. If you need assistance, please cont... | 2 months ago | 1 |
| 5 | Rochelle Marie | 2024-01-09 | This a ZERO star review . Worst RG&E ever . Ho... | 16 | NaN | NaN | 1 |
| 6 | Cakes Blue | 2024-01-09 | First three month of living at my new place . ... | 7 | NaN | NaN | 1 |
| 7 | Nathan Scott | 2024-03-09 | My bill have go from about $ 80 a month to ove... | 2 | Hi Nathan. We're very sorry to hear about your... | 4 months ago | 1 |
| 8 | Kim Ganley | 2024-06-09 | RG&E be terribly inefficient . I do not know h... | 1 | Hi Kim. We're very sorry to hear about your ex... | a month ago | 1 |
| 9 | MEHRI DALAI | 2024-03-09 | 0 star ! This dumb , scamming donkey behind RG... | 1 | Hi Mehri. We're very sorry to hear about your ... | 4 months ago | 1 |
EXAMPLE
Summary: the descriptions used for each term shows that customers are unhappy.
Aspect Sentiment analyzer
Summary:
Sentiments associated with each aspect shows that there are more negative sentiments than positive sentiments for each term.